﻿CREATE TABLE [ODData].[Sample] (
    [SampleID]             INT           IDENTITY (1, 1) NOT NULL,
    [SampleCode]           VARCHAR (150) NULL,
    [SampleQuantity]       REAL          NOT NULL,
    [SampleQuantityUnitID] INT           NOT NULL,
    [SampleTypeID]         INT           NOT NULL,
    [CollectionMethodText] VARCHAR (550) NULL,
    [PreservationMethodID] INT           NOT NULL
);

